How to: Set print titles.
Solution:
Select 'Page Setup...' from the 'File' menu. Click the 'Sheet' tab from the 'Page Setup' dialog box and type the cell references for the rows and/or columns containing the titles to print.
1) Select the 'File' menu and select 'Page Setup...'. (The Page Setup dialog box appears.)
2) Click 'Sheet' tab.
3) Do one or both of the following:
4) Click 'OK'.
NOTE: The titles will print twice if the rows and/or columns are also included in the print area.